package com.xyw.his00.mapper;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.xyw.his00.dto.OrderDTO;
import com.xyw.his00.pojo.dbpojo.Register;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface RegisterMapper extends BaseMapper<Register> {

    List<OrderDTO> getOrderDTO(int id);


    //${}注入
  //  @Select("SELECT real_name FROM register WHERE case_number=${id} LIMIT 0,1")
    @Select("SELECT real_name FROM register WHERE case_number='${id}' LIMIT 0,1")
//    @Select("SELECT real_name FROM register WHERE case_number='${id} LIMIT 0,1")
//    @Select("SELECT real_name FROM register WHERE case_number=${id}' LIMIT 0,1")
  String selectByID(String id);
    //#{}注入
    @Select("SELECT real_name FROM register WHERE case_number=#{id}")
    boolean selectById(String id);
}
